joins with subquery

visit shbcf.ru